ALTER TABLE [dbo].[t_pond_history] ADD [is_repair] int  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [is_clear] int  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [trapped_person] int  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [trapped_car] int  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [cause] nvarchar(2500) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [front_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [in_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
GO

ALTER TABLE [dbo].[t_pond_history] ADD [later_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否处置 1是0否',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'is_repair'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否已清除 1是0否',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'is_clear'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困人员数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'trapped_person'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困车辆数量(辆)',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'trapped_car'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水原因',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'cause'
GO

EXEC sp_addextendedproperty
'MS_Description', N'处置前图片',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'front_dispose_url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'处置中图片url',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'in_dispose_url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'处置后图片',
'SCHEMA', N'dbo',
'TABLE', N't_pond_history',
'COLUMN', N'later_dispose_url'

CREATE TABLE [dbo].[t_rain_reported] (
  [id] bigint  NOT NULL,
  [regional_id] bigint  NOT NULL,
  [region_id] bigint  NOT NULL,
  [pond_count] int DEFAULT 0 NOT NULL,
  [trapped_person] int DEFAULT 0 NOT NULL,
  [trapped_car] int DEFAULT 0 NOT NULL,
  [unquenched_pond_count] int DEFAULT 0 NOT NULL,
  [pass_pond_count] int DEFAULT 0 NOT NULL,
  [break_pond] int DEFAULT 0 NOT NULL,
  [break_no_pond] int DEFAULT 0 NOT NULL,
  [break_pass_pond] int DEFAULT 0 NOT NULL,
  [act_person] int DEFAULT 0 NOT NULL,
  [act_special_car] int DEFAULT 0 NOT NULL,
  [act_car] int DEFAULT 0 NOT NULL,
  [act_equipment] int DEFAULT 0 NOT NULL,
  [pond_capacity] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [create_user] bigint  NULL,
  [create_time] datetime  NULL,
  [update_user] bigint  NULL,
  [update_time] datetime  NULL,
  [is_deleted] int  NULL,
  CONSTRAINT [PK__t_rain_r__3213E83F4F7F8022] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_rain_reported] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属分区id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'regional_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属区域id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'region_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水点数量',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'pond_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困人员数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'trapped_person'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困车辆数量(辆)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'trapped_car'
GO

EXEC sp_addextendedproperty
'MS_Description', N'未消除积水点(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'unquenched_pond_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'已消除积水点(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'pass_pond_count'
GO

EXEC sp_addextendedproperty
'MS_Description', N'断交积水点数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'break_pond'
GO

EXEC sp_addextendedproperty
'MS_Description', N'断交未恢复积水点数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'break_no_pond'
GO

EXEC sp_addextendedproperty
'MS_Description', N'断交已恢复积水点数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'break_pass_pond'
GO

EXEC sp_addextendedproperty
'MS_Description', N'派出人员数量(人次)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'act_person'
GO

EXEC sp_addextendedproperty
'MS_Description', N'派出特种车辆(车次)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'act_special_car'
GO

EXEC sp_addextendedproperty
'MS_Description', N'派出载人车辆数量（车次)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'act_car'
GO

EXEC sp_addextendedproperty
'MS_Description', N'派出防涝设备数量(台次)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'act_equipment'
GO

EXEC sp_addextendedproperty
'MS_Description', N'抽排能力(立方米/小时)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported',
'COLUMN', N'pond_capacity'
GO

EXEC sp_addextendedproperty
'MS_Description', N'雨中速报',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported'









CREATE TABLE [dbo].[t_rain_reported_pond] (
  [rain_reported_id] bigint  NOT NULL,
  [pond_id] bigint  NOT NULL,
  [depth] decimal(24,6)  NULL,
  [occur_time] datetime  NOT NULL,
  [exit_time] datetime  NULL,
  [area] decimal(24,6)  NULL,
  [exit_duration] decimal(24,6)  NULL,
  [break_duration] decimal(24,6)  NULL,
  [is_repair] int  NULL,
  [is_clear] int  NULL,
  [trapped_person] int  NULL,
  [trapped_car] int  NULL,
  [cause] nvarchar(2500) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [front_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [in_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [later_dispose_url] nvarchar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [pond_history_id] bigint  NULL,
  [id] bigint  NOT NULL,
  CONSTRAINT [PK__t_rain_r__B367518E566F5FBB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_rain_reported_pond] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'雨中速报id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'rain_reported_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水点id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'pond_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水点深度(厘米)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'depth'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水发生时间',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'occur_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水消退时间',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'exit_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水面积(平方米)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'area'
GO

EXEC sp_addextendedproperty
'MS_Description', N'退水时长(小时)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'exit_duration'
GO

EXEC sp_addextendedproperty
'MS_Description', N'断交时长(小时)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'break_duration'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否处置 1是0否',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'is_repair'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否已清除 1是0否',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'is_clear'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困人员数量(个)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'trapped_person'
GO

EXEC sp_addextendedproperty
'MS_Description', N'受困车辆数量(辆)',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'trapped_car'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水原因',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'cause'
GO

EXEC sp_addextendedproperty
'MS_Description', N'处置前图片',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'front_dispose_url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'处置中图片url',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'in_dispose_url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出之后图片',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'later_dispose_url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'积水点历史id',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'pond_history_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'雨中速报子表',
'SCHEMA', N'dbo',
'TABLE', N't_rain_reported_pond'
